SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweDocumentacion
AS
SELECT     IdDocumentacion AS ID,
		   FechaEntrada,
		   OrganismoRemitente,
		   NombreInstitucion,
		   Firma,
		   Localidad,
		   Motivo,
		   Observaciones
FROM       dbo.tb_Documentacion

GO
GRANT SELECT ON  [dbo].[vweDocumentacion] TO [GestionDespacho]
GRANT INSERT ON  [dbo].[vweDocumentacion] TO [GestionDespacho]
GRANT DELETE ON  [dbo].[vweDocumentacion] TO [GestionDespacho]
GRANT UPDATE ON  [dbo].[vweDocumentacion] TO [GestionDespacho]
GRANT SELECT ON  [dbo].[vweDocumentacion] TO [Informatica]
GRANT INSERT ON  [dbo].[vweDocumentacion] TO [Informatica]
GRANT DELETE ON  [dbo].[vweDocumentacion] TO [Informatica]
GRANT UPDATE ON  [dbo].[vweDocumentacion] TO [Informatica]
GRANT SELECT ON  [dbo].[vweDocumentacion] TO [SoloVer]
GO
